package com.trkj.dao.lzs;


import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.trkj.pojo.Salary;


public interface PayrollDao  extends  CrudRepository<Salary, Long>{

	     @Query("from Salary s where s.salaryName like ?1")
	     public  List<Salary>queryByName(String text);	
	     
	     @Query("SELECT s,p FROM Salary s inner join s.salaryAccount p")
	 	public List<Object[]> find_payroll();

//	     @Query("from Salary e")
//	 	public List<Salary> queryByPage(Pageable p);
	}


